orcli export tsv

export tab-separated values (TSV)

Usage

Arguments

PROJECT project name or id (required)

Options

--select COLUMNS		`filter result set to one or more columns (comma separated) example: --select "foo,bar,baz"`
--mode MODE		`specify if project contains multi-row records`
--facets FACETS		`filter result set by providing an OpenRefine facets config in json`
--output FILE		`Write to file instead of stdout`
--encoding ENCODING		`set character encoding`
--quiet, -q		`suppress log output, print errors only`

Parent Environment Variables

OPENREFINE_URL URL to OpenRefine server

Examples

orcli export tsv "duplicates"

orcli export tsv "duplicates" --output "duplicates.tsv"

orcli export tsv "duplicates" --encoding "ISO-8859-1"

orcli export tsv "duplicates" --select "name,email,purchase"

orcli export tsv "duplicates" --facets '[ { "type": "text", "columnName": "name", "mode": "regex", "caseSensitive": false, "invert": false, "query": "^Ben" } ]'

orcli export tsv "duplicates" --facets '[{ "type": "list", "expression": "grel:filter([\"gender\",\"purchase\"],cn,cells[cn].value.find(/^F/).length()>0).length()>0", "columnName": "", "selection": [{"v": {"v": true}}] }]'